Cannot center entry across multiple cells due to space in one of the cells.

Cause:


This problem occurs because there is a space character typed in one of the cells (other than the entry).

Solution:


Select and clear the contents of all the cells except the one that contains the entry.